UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hiSxriyI2c3rXa+7N4k1frWv169aMlfpTB/KEp8PC1s=' 
WHERE 
  key_id = '78b2b59de984b51168651b96dcd5f545fc15d44837603d581787e50cd5489de2' 
  AND (
    token = 'hiSxriyI2c3rXa+7N4k1frWv169aMlfpTB/KEp8PC1s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022