UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PTatEhSMWJ+mXu1mDVn7ay3igz1N0zJNliIDe/b3fBI=' 
WHERE 
  key_id = '5fee70eecb62211a4a862372df3a56c33ec30b6c1b5295779daf301b106df6b0' 
  AND (
    token = 'PTatEhSMWJ+mXu1mDVn7ay3igz1N0zJNliIDe/b3fBI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024