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