UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XljgVaJL2qWLzc3G+kIY0y1DUYOS/GOy4fQY4VM4rqc=' 
WHERE 
  key_id = '456452f20f1bf27a1e7aa2d5a5a8cf9c603fb2f0496ba65264d9ed71d13d6c76' 
  AND (
    token = 'XljgVaJL2qWLzc3G+kIY0y1DUYOS/GOy4fQY4VM4rqc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030