UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6pFRmTtM/9nprJjbFyg/0jmkCh2dkyDlEkOGPINf4c='
WHERE
key_id = 'a436b77ec48fd50f351c2c147f71ac7e882be4639e9eae359f221988a77f53ea'
AND (
token = 'N6pFRmTtM/9nprJjbFyg/0jmkCh2dkyDlEkOGPINf4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)