UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRLzlfS8xWpk3cMT9SjMVi6tij3o5017DBz812DzRrA='
WHERE
key_id = 'bf07a1bbc448bb4ab64adb0801cf602c28b52c844d0828e688bcf7923f96c184'
AND (
token = 'zRLzlfS8xWpk3cMT9SjMVi6tij3o5017DBz812DzRrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)