UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CQiuRjvCB6Ij4rOP1VtSahc4QUy2MF/55l8U7wL5/u0=' 
WHERE 
  key_id = 'a7dc4d6735978faa0ec1a97648419c7457bd7f4eb6a71d0109ef6216cdba0c4f' 
  AND (
    token = 'CQiuRjvCB6Ij4rOP1VtSahc4QUy2MF/55l8U7wL5/u0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020