UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qINGz6h26HXOEn4EV25YZ7tcbcaMInYuwRRntG+n5hg='
WHERE
key_id = 'e4d0389a7fcc8b5657f4806d3f58842fe44d0455f0a20dc03108d5107d0c42cc'
AND (
token = 'qINGz6h26HXOEn4EV25YZ7tcbcaMInYuwRRntG+n5hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)