UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTpblIeTB1n+NgkxToZ0ByCfOudA4RjUItU7Lfz1lXg='
WHERE
key_id = '8cd183e26425632dc08a4b88f4de4fe767a19cb952c7924d242f100b940cda5c'
AND (
token = 'ZTpblIeTB1n+NgkxToZ0ByCfOudA4RjUItU7Lfz1lXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)