UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KXKmyX3a8moNB6UiaRGTX6gnShB3F8NfoFftBXOYC8='
WHERE
key_id = '7e5914ac981df17cbe69bb9ed6aceb422bc26a742e0c8a1fb7bad94beb508b3e'
AND (
token = '1KXKmyX3a8moNB6UiaRGTX6gnShB3F8NfoFftBXOYC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)