UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mYQSyh4tohM+uBBccnMk/Us/+8SpEeRAsrEMhQe62w='
WHERE
key_id = '4abc270ddd23357e91290581f939a01c85014a9f69b4b0b477e8af15f9e137c9'
AND (
token = '8mYQSyh4tohM+uBBccnMk/Us/+8SpEeRAsrEMhQe62w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)