UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yHshpi/tblssb8jBSVB4SQuH4YWXpG0+6almMsX5xVQ=' 
WHERE 
  key_id = '92679d4ec6eb144eb6d59c72b4e77c74fe5a52e4bf990ffc91e5f7dc390c6f2f' 
  AND (
    token = 'yHshpi/tblssb8jBSVB4SQuH4YWXpG0+6almMsX5xVQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048