UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaQJ2ZuiDuo0udiBS8MM47BoyByng1T/pPaZAovR4ZA='
WHERE
key_id = 'cfaf50bdbb4c3e18b8053a8ff0ea6c4aa4488c3b3ed5d933f522a0b19681a481'
AND (
token = 'zaQJ2ZuiDuo0udiBS8MM47BoyByng1T/pPaZAovR4ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)