UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dD/4GpF0cNCJq5SobQAOnqhWIQjNw9xDDikz0MaZdcY='
WHERE
key_id = '4078eba6ac141501c6b54e5fbb4d92ea688118540ef374f374e33713a8536895'
AND (
token = 'dD/4GpF0cNCJq5SobQAOnqhWIQjNw9xDDikz0MaZdcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)