UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGag3otZVi573c2T2v+EWNd6yTbtgNU6pYXt0fPM3S4='
WHERE
key_id = '6fe504e48403d28b81f977b474e23d90e3c359f64eeeb8bb9d9e781c9a97a3a3'
AND (
token = 'tGag3otZVi573c2T2v+EWNd6yTbtgNU6pYXt0fPM3S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)