UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gLk/TodMAEFNDnSHl7lSXqPomk4XAaIopGI0W45RGcY='
WHERE
key_id = '19bd197c8d765d1862c130402aba0b4849b59cf6c10a1c4f208626bcc41374bf'
AND (
token = 'gLk/TodMAEFNDnSHl7lSXqPomk4XAaIopGI0W45RGcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)