UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uAztbRAemRveu/Uv9YR5J3zd4PR8gIIF3jIBhkGPaQ4='
WHERE
key_id = 'ac8a80461c18b244e775224b825d808ead7391ebeaa7ffc510184560c9243667'
AND (
token = 'uAztbRAemRveu/Uv9YR5J3zd4PR8gIIF3jIBhkGPaQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)