UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1RvS/ckSKnebIYCbM7SVEgCxJMbrPCCsDr8e5mpQzc='
WHERE
key_id = '5b142d54071c42efb80ced3511eac0dbd23d394523fb0d4d70b45b0e5bb52195'
AND (
token = 'a1RvS/ckSKnebIYCbM7SVEgCxJMbrPCCsDr8e5mpQzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)