UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z+Z3jM66Ab6cxHgXW031GH77W05wXnSPOvtXeVUcZWQ=' 
WHERE 
  key_id = 'afa93f2db634bb6e0c39e302cde30686a99a703c6bc2c29f42bb218ad5f4125c' 
  AND (
    token = 'Z+Z3jM66Ab6cxHgXW031GH77W05wXnSPOvtXeVUcZWQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025