UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfYgdtPjhRwmWl11veoN2Qz1qatE7ztcVJ9AECJarLs='
WHERE
key_id = '05053d2e1bb64183e55a47470ddfe5e33f8571a9a1d3d7b97d70b734884ff1b2'
AND (
token = 'ZfYgdtPjhRwmWl11veoN2Qz1qatE7ztcVJ9AECJarLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)