UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMyHUjdeZZ9MWHVcJCSc7LfV+PzjkQjoGUnpxRVrrew='
WHERE
key_id = 'b12c2a6e50938a2aeb067ae00afae68cd3a77db5c00be1458a7decb4ef6fcca1'
AND (
token = 'ZMyHUjdeZZ9MWHVcJCSc7LfV+PzjkQjoGUnpxRVrrew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)