UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQQndAW+SbWFn747eZ0J5pkzDxdNr31XCOXRovT/KqA='
WHERE
key_id = '394cc3d80d3b5284e72ef28c753c4111c8dfd98733f087579f8072dad39c9fdc'
AND (
token = 'XQQndAW+SbWFn747eZ0J5pkzDxdNr31XCOXRovT/KqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)