UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SwjsgnxT86xLIqfToOI8xDXSknM9899k3BATbZM9xQ='
WHERE
key_id = 'e6788a0c58ab57bdaf04d88056024a971a69bb7a11651cc82a40d4ded85f8d1a'
AND (
token = '3SwjsgnxT86xLIqfToOI8xDXSknM9899k3BATbZM9xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)