UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yGcw5OQMjbtE8X11rNoiU6Uav6T4bP+3KaRdysYFUb0=' 
WHERE 
  key_id = '0d5ca2a533f2afffd4c6e1fa29be2a846f760d76eb23031df582d37c5c0b37a7' 
  AND (
    token = 'yGcw5OQMjbtE8X11rNoiU6Uav6T4bP+3KaRdysYFUb0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045