UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lB5N01b3SMkjlVBLzwkQZI8s3wIsjOWVrguKCIz3r40='
WHERE
key_id = '92c0ce32273de2a7af3e0fce8a0f749e4f8217c879a4f2ec769c81346a2e1d7a'
AND (
token = 'lB5N01b3SMkjlVBLzwkQZI8s3wIsjOWVrguKCIz3r40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)