UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jR19WanG/RNh9cq6kTOmcjM8TIrkPCdUZm3HaSz0cfI='
WHERE
key_id = '6e96be5f23d15dbcf077e111d8606c46c4140c66a83d3402e6c4fcae5141a652'
AND (
token = 'jR19WanG/RNh9cq6kTOmcjM8TIrkPCdUZm3HaSz0cfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)