UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JPQW47kGGZumY9XQCAy/0extC/sAOPE9rTLzd4Aee+U='
WHERE
key_id = 'b31f2a33c4e84e93e1106e52faedc2ddb13dec599275b9d7547210ff25142308'
AND (
token = 'JPQW47kGGZumY9XQCAy/0extC/sAOPE9rTLzd4Aee+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)