UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '05YlPzAVWx7W+giGVMBdg2fO8QjV9028KDpJLBkyhmM=' 
WHERE 
  key_id = 'dc99e23541a09622ba510d950da7a09c0a88bf83328951347b9d3590cd2bd056' 
  AND (
    token = '05YlPzAVWx7W+giGVMBdg2fO8QjV9028KDpJLBkyhmM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016