UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXsHqF1YeAZdgRbCYxQwHRfJOzjInNW9ahaM5JiP4+Y='
WHERE
key_id = 'f6ec0b38240f6940c096afdced97fcd0cc65d33f52268386af66c72ac0cef192'
AND (
token = 'bXsHqF1YeAZdgRbCYxQwHRfJOzjInNW9ahaM5JiP4+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)