UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kK77ZN96m/kYE7SqZSxjPsvtn91BSNzbS0yBtaZJSro=' 
WHERE 
  key_id = 'eb4b536b83be4a3ee7c3fde939032e8941e282c14efa0d52ad34e3888d1fdec1' 
  AND (
    token = 'kK77ZN96m/kYE7SqZSxjPsvtn91BSNzbS0yBtaZJSro=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027