UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7W+uGNkilR/gKT0H7s8MVgCCUWrvg1jAuHwZxRCmn0='
WHERE
key_id = 'd953c27da566f2decfb9ff2146f308aceb7493673fbba318b4ecf95356a5e487'
AND (
token = 'U7W+uGNkilR/gKT0H7s8MVgCCUWrvg1jAuHwZxRCmn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)