UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gxf6VLInKvYu2zbz4ra3sKdVezHeEHapE1J/J6GnUrA='
WHERE
key_id = 'cf9fdd57960eebd91a12fd3f7107e71bf24b4faa8afa33e1d361f95e1fd2a225'
AND (
token = 'Gxf6VLInKvYu2zbz4ra3sKdVezHeEHapE1J/J6GnUrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)